{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"FIELD_FILE","type":"character","width":5},{"name":"FIELD_NAME","type":"character","width":24},{"name":"FIELD_TYPE","type":"character","width":1},{"name":"FIELD_LEN","type":"number","width":3,"decimals":0},{"name":"FIELD_DESC","type":"character","width":26},{"name":"FIELD_PICT","type":"character","width":20},{"name":"FIELD_CASE","type":"logical","width":1},{"name":"FIELD_VALD","type":"character","width":80},{"name":"FIELD_MESG","type":"character","width":74}],"n_rows":241,"rows_kept":241,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
["AA001","DATE","D",8,"Appointment Date","99/99/99",false,null,null]
["AA002","LASTNAME","C",20,"Last Name",null,false,null,null]
["AA003","COMPANY","C",30,"Company or Employer",null,false,null,null]
["AA004","TYPE","C",1,"Type of Appointment","!",false,null,null]
["AA005","TDESCRIP","C",20,"Type Description",null,false,null,null]
["AA006","SUBJECT","C",30,"Subject of Appointment",null,false,null,null]
["AA007","STATUS","C",1,"Appointment Status","!",false,null,null]
["AA008","SDESCRIP","C",20,"Status Description",null,false,null,null]
["AA009","D_DAY","C",10,"Day of Week",null,false,null,null]
["AA010","M_DAY","C",20,"Full Month Name",null,false,null,null]
["EA001","DATE","D",8,"Date of Expense","99/99/99",false,null,null]
["EA002","TYPE","C",15,"Type of Expense",null,false,null,null]
["EA003","DESCRIP","C",30,"Expense Description",null,false,null,null]
["EA004","PURPOSE","C",27,"Purpose of Expense",null,false,null,null]
["EA005","PARTY","C",30,"In the Service Of...",null,false,null,null]
["EA006","FULLNAME","C",30,"Last Name of Person Paid",null,false,null,null]
["EA008","AMOUNT","N",10,"Amount of Expense","9999999.99",false,"gv > 0","Amount Must Be Greater ZERO!"]
["EA009","REIMBURS","C",1,"Reimbursed (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter a Y or N Only!"]
["EA010","DATREIMB","D",8,"Date Reimbursed","99/99/99",false,null,null]
["EA011","DIFF","N",10,"Balance Outstanding","9999999.99",false,"gv >= 0","Amount Must Be Greater Than OR Equal to ZERO!"]
["EA012","AUTO","C",1,"Automobile Expense (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter a Y or N Only!"]
["EA013","MILEAGE","N",5,"Amount of Travel Mileage",null,false,"gv > 0","Amount Must Be Greater Than ZERO!"]
["FA001","LASTNAME","C",20,"Last Name",null,false,null,null]
["FA002","EMPLOYER","C",30,"Company/Employer",null,false,null,null]
["FA003","SUBJECT","C",30,"Subject of Follow Up",null,false,null,null]
["FA004","CDATE","D",8,"Date of Initial Contact","99/99/99",false,null,null]
["FA005","CTYPE","C",1,"Type of Initial Contact","!",false,null,null]
["FA006","CDESCRIP","C",20,"Description of Contact",null,false,null,null]
["FA007","DATE","D",8,"Follow Up Date","99/99/99",false,null,null]
["FA008","TYPE","C",1,"Type of Follow Up","!",false,null,null]
["FA009","TDESCRIP","C",20,"Description of Follow Up",null,false,null,null]
["FA010","STATUS","C",1,"Follow Up Status","!",false,null,null]
["FA011","SDESCRIP","C",10,"Status Description",null,false,null,null]
["NA001","LASTNAME","C",20,"Last Name",null,false,null,null]
["NA002","EMPLOYER","C",30,"Company/Employer",null,false,null,null]
["NA003","BUSCITY","C",20,"Company/Employer City",null,false,null,null]
["NA004","BUSSTATE","C",2,"Company/Employer State","!!",false,null,null]
["NA005","BUSZIP","C",10,"Company/Employer Zip Code",null,false,null,null]
["NA006","BPROV","C",15,"Company/Employer Province",null,false,null,null]
["NA007","BUSTYPE","C",30,"Type of Business",null,false,null,null]
["NA008","CUSTOMER","C",1,"Customer (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter a Y or N Only!"]
["NA009","CUSTNUM","C",17,"Customer Number","!!!-999999-999999",false,null,null]
["NA010","HOMCITY","C",20,"Home City",null,false,null,null]
["NA011","HOMSTATE","C",2,"Home State","!!",false,null,null]
["NA012","HOMZIP","C",10,"Home Zip Code",null,false,null,null]
["NA013","HPROV","C",15,"Home Province",null,false,null,null]
["NA014","AGE","N",3,"Person's Age","999",false,null,null]
["NA015","DOB","D",8,"Person's Date of Birth","99/99/99",false,null,null]
["NA016","SEX","C",1,"Person's Sex","!",false,"gv = 'M' .or. gv = 'F'","Enter M or F Only!"]
["CA001","DATE","D",8,"Date of Communication","99/99/99",false,null,null]
["CA002","LASTNAME","C",20,"Communicator's Last Name",null,false,null,null]
["CA003","COMPANY","C",30,"Company/Employer",null,false,null,null]
["CA004","BUSCITY","C",20,"Company/Employer City",null,false,null,null]
["CA005","BUSSTATE","C",2,"Company/Employer State","!!",false,null,null]
["CA006","BUSZIP","C",10,"Company/Employer Zip Code",null,false,null,null]
["CA007","BPROV","C",15,"Company/Employer Province",null,false,null,null]
["CA008","HOMCITY","C",20,"Person's Home City",null,false,null,null]
["CA009","HOMSTATE","C",2,"Person's Home State","!!",false,null,null]
["CA010","HOMZIP","C",10,"Person's Home Zip Code",null,false,null,null]
["CA011","HPROV","C",15,"Person's Home Province",null,false,null,null]
["CA012","TYPE","C",1,"Type of Communication","!",false,null,null]
["CA013","TDESCRIP","C",20,"Type Description",null,false,null,null]
["CA014","FOLLOWUP","C",1,"Follow Up (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter Y or N Only!"]
["CA015","FOLLDATE","D",8,"Follow Up Date","99/99/99",false,null,null]
["CA016","FTYPE","C",1,"Follow Up Type","!",false,null,null]
["CA017","FDESCRIP","C",20,"Follow Up Description",null,false,null,null]
["CA018","SUBJECT","C",30,"Subject of Communication",null,false,null,null]
["CA019","COMMENT","C",24,"Communication Comment",null,false,null,null]
["TA001","DATE","D",8,"Task ToDo Date","99/99/99",false,null,null]
["TA002","TASK","C",50,"Task To Do",null,false,null,null]
["TA003","PRIORITY","C",1,"Task Priority","9",false,"gv = '1' .or. gv = '2' .or. gv = '3' .or. gv = '4' .or. gv = '5'","Priority Must be a Number From 1 to 5 Only!"]
["TA004","DONE","C",1,"Task Completed (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter a Y or N Only!"]
["TA005","WHENDONE","D",8,"Task Completion Date","99/99/99",false,null,null]
["TA006","DAYS","N",5,"Number of Days to Complete","99999",false,null,null]
["IA001","DATE","D",8,"Invoice/Transaction Date","99/99/99",false,null,null]
["IA002","TRANSNUM","C",17,"Transaction Number","!!!-999999-999999",false,null,null]
["IA003","CUSTNUM","C",17,"Client Number","!!!-999999-999999",false,null,null]
["IA004","LASTNAME","C",20,"Client's Last Name",null,false,null,null]
["IA005","EMPLOYER","C",30,"Client Company/Employer",null,false,null,null]
["IA006","CITY","C",20,"Client City",null,false,null,null]
["IA007","STATE","C",2,"Client State","!!",false,null,null]
["IA008","ZIP","C",10,"Client Zip Code",null,false,null,null]
["IA009","PROV","C",15,"Client Province",null,false,null,null]
["IA010","SCODE","C",3,"Service Code","!!!",false,null,null]
["IA011","SDESCRIP","C",30,"Service Description",null,false,null,null]
["IA012","DAY_HOUR","C",1,"Billed By Day or By Hour","!",false,"gv = 'D' .or. gv = 'H'","Enter a D or H Only!"]
["IA013","HOURS","N",7,"Number of Hours Billed","9999.99",false,"gv > 0","Number of Hours Billed Must Be Greater Than ZERO!"]
["IA014","HRATE","N",7,"Hourly Rate","9999.99",false,"gv > 0","Rate Must Be Greater Than ZERO!"]
["IA015","DAYS","N",7,"Number of Days Billed","9999.99",false,"gv > 0","Days Must Be Greater Than ZERO!"]
["IA016","DRATE","N",7,"Daily Rate","9999.99",false,"gv > 0","Rate Must Be Greater Than ZERO!"]
["IA017","AMOUNT","N",10,"Invoice Amount","9999999.99",false,"gv > 0","Amount Must Be Greater Than ZERO!"]
["IA018","EXPENSES","N",10,"Billable Expenses","9999999.99",false,"gv > 0","Amount Must Be Greater Than ZERO!"]
["IA019","PAID","N",10,"Paid Amount","9999999.99",false,"gv > 0","Amount Must Be Greater Than ZERO!"]
["IA020","PDATE","D",8,"Date Paid","99/99/99",false,null,null]
["IA021","IAGE","N",3,"Age of Receivable in Days","999",false,"gv >= 0","Amount Must Be Greater Than OR Equal to Zero!"]
["IA022","BAL","N",10,"Balance Due","9999999.99",false,"gv >= 0","Amount Must Be Greater Than OR Equal to Zero!"]
["SA001","LASTNAME","C",20,"Last Name",null,false,null,null]
["SA002","COMPANY","C",35,"Company/Employer",null,false,null,null]
["SA003","CITY","C",20,"City",null,false,null,null]
["SA004","STATE","C",2,"State","!!",false,null,null]
["SA005","ZIP","C",10,"Zip Code",null,false,null,null]
["SA006","PROV","C",15,"Province",null,false,null,null]
["SA007","ON1","D",8,"Contact Date","99/99/99",false,null,null]
["SA008","TYPE1","C",1,"Contact Type","!",false,null,null]
["SA009","DESC1","C",20,"Contact Description",null,false,null,null]
["SA010","SUBJ","C",30,"Subject of Contact",null,false,null,null]
["SA011","FOLLOW","C",1,"Requires Follow Up (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter a Y or N Only!"]
["SA012","WHEN","D",8,"Follow Up Date","99/99/99",false,null,null]
["SA013","TYPE2","C",1,"Follow Up Type","!",false,null,null]
["SA014","DESC2","C",20,"Follow Up Description",null,false,null,null]
["SA015","REPLY","C",1,"Replied (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter Y or N Only!"]
["SA016","WHEN2","D",8,"Date Replied","99/99/99",false,null,null]
["SA017","TYPE3","C",1,"Type of Reply","!",false,null,null]
["SA018","INNAME","C",1,"In Master Name File (Y/N)?","!",false,"gv = 'Y' .or. gv = 'N'","Enter a Y or N Only!"]
["MA001","LASTNAME","C",20,"Last Name",null,false,null,null]
["MA002","EMPLOYER","C",30,"Company/Employer",null,false,null,null]
["MA003","CITY","C",20,"City",null,false,null,null]
["MA004","STATE","C",2,"State","!!",false,null,null]
["MA005","ZIP","C",10,"Zip Code",null,false,null,null]
["MA006","PROV","C",15,"Province",null,false,null,null]
["MA007","AMOUNT","N",10,"Amount","9999999.99",false,null,null]
["MA008","EXPENSE","N",10,"Expense Amount","9999999.99",false,null,null]
["MA009","PAID","N",10,"Amount Paid","9999999.99",false,null,null]
["MA010","BAL","N",10,"Balance Due","9999999.99",false,null,null]
["WL001","DATE","D",8,"Task Date","99/99/99",false,null,null]
["WL002","START","C",5,"Task Start Time","99:99",false,null,null]
["WL003","SAMPM","C",2,"Start Time is AM or PM","!!",false,"gv = 'AM' .or. gv = 'PM'","Must enter AM or PM only!"]
["WL004","END","C",5,"Task End Time","99:99",false,null,null]
["WL005","EAMPM","C",2,"End Time AM or PM","!!",false,"gv = 'AM' .or. gv = 'PM'","Must be AM or PM only!"]
["WL006","TASK","C",60,"Task Description",null,false,null,null]
["WL007","NOTES","M",10,"Task Notes",null,false,null,null]
["NA017","NOTES","M",10,"Notes",null,false,null,null]
["AA011","ANOTES","M",10,"Notes",null,false,null,null]
["FA012","NOTES","M",10,"Notes",null,false,null,null]
["EA014","NOTES","M",10,"Notes",null,false,null,null]
["CA020","CNOTES","M",10,"Notes",null,false,null,null]
["TA007","TNOTES","M",10,"Notes",null,false,null,null]
["IA023","NOTES","M",10,"Notes",null,false,null,null]
["SA019","NOTES","M",10,"Notes",null,false,null,null]
["CL001","CLASSNUM","C",7,"Course Code","!!!9999",false,null,null]
["CL002","CLASSS","C",30,"Course Name",null,false,null,null]
["CL003","FROM_D","D",8,"Start Date","99/99/99",false,null,null]
["CL004","FROM_T","C",5,"Start Time","99:99",false,null,null]
["CL005","TO_D","D",8,"End Date","99/99/99",false,null,null]
["CL006","TO_T","C",5,"End Time","99:99",false,null,null]
["CL007","FEE","N",9,"Course Fee","999,999.99",false,null,null]
["CL008","WHERE","C",30,"Location",null,false,null,null]
["CL009","MAX","N",3,"Maximum Attendance","999",false,null,null]
["CL010","ATTEND","N",3,"Number Registered","999",false,null,null]
["CL011","STATUS","C",1,"Status","!",false,"gv = 'S' .or. gv = 'C' .or. gv = 'X' .or. gv = 'I' .or. gv = 'P'","S=Scheduled  C=Completed  X=Cancelled  I=In Progress  P=Postponed"]
["CL012","NOTES","M",10,"Notes",null,false,null,null]
["RE001","LASTNAME","C",15,"Last Name",null,false,null,null]
["RE002","FIRNAME","C",12,"First Name",null,false,null,null]
["RE003","COMPANY","C",30,"Company",null,false,null,null]
["RE004","TITLE","C",20,"Title",null,false,null,null]
["RE005","ADDR1","C",30,"Address-1",null,false,null,null]
["RE006","ADDR2","C",30,"Address-2",null,false,null,null]
["RE007","CITY","C",20,"City",null,false,null,null]
["RE008","STATE","C",2,"State","!!",false,null,null]
["RE009","ZIP","C",10,"Zip Code","!!!!!!!!!!",false,null,null]
["RE010","PROV","C",20,"Province",null,false,null,null]
["RE011","BPHONE","C",14,"Business Phone","(999) 999-9999",false,null,null]
["RE012","EXT","C",5,"Extension","#####",false,null,null]
["RE013","HPHONE","C",14,"Home Phone","(999) 999-9999",false,null,null]
["RE014","FAX","C",14,"Fax","(999) 999-9999",false,null,null]
["RE015","CLASS","C",30,"Course Name",null,false,null,null]
["RE016","CLASSNUM","C",7,"Course Code","!!!9999",false,null,null]
["RE017","FROM_D","D",8,"Start Date","99/99/99",false,null,null]
["RE018","FROM_T","C",5,"Start Time","99:99",false,null,null]
["RE019","TO_D","D",8,"End Date","99/99/99",false,null,null]
["RE020","TO_T","C",5,"End Time","99:99",false,null,null]
["RE021","WHERE","C",30,"Location",null,false,null,null]
["RE022","FEE","N",9,"Course Fee","999,999.99",false,null,null]
["RE023","REGDATE","D",8,"Date Registered","99/99/99",false,null,null]
["RE024","AMTPAID","N",9,"Amount Paid","999,999.99",false,null,null]
["RE025","HOWPAID","C",1,"How Paid","!",false,"gv='C' .or. gv='K' .or. gv='M' .or. gv='R' .or. gv='O'","C=Cash  K=Cash  M=Money Order  R=Charge  O=Other"]
["RE026","CHECKNUM","C",5,"Check Number","#####",false,null,null]
["RE027","CHKDATE","D",8,"Check Date","99/99/99",false,null,null]
["RE028","CREDIT","C",1,"Charge Card","!",false,"gv='M' .or. gv='V' .or. gv='A' .or. gv='D' .or. gv='O'","M=Master Card  V=Visa  A=American Express  D=Discover  O=Optima"]
["RE029","CNUM","C",19,"Card Number","####-####-####-####",false,null,null]
["RE030","EXPIRE","C",5,"Card Expiration","99/99",false,null,null]
["RE031","BAL","N",9,"Balance Due","999,999.99",false,null,null]
["RE032","PAID_D","D",8,"Date Paid","99/99/99",false,null,null]
["RE033","CANCEL","C",1,"Cancellation?","!",false,"gv='Y' .or. gv='N'","Y=Yes  N=No"]
["RE034","CANDATE","D",8,"Date Cancelled","99/99/99",false,null,null]
["RE035","ATTEND","C",1,"Attended?","!",false,"gv='Y' .or. gv='N'","Y=Yes  N=No"]
["RE036","EVAL_T","C",1,"Instructor Evaluation","9",false,"gv='0' .or. gv='1' .or. gv='2' .or. gv='3' .or. gv='4' .or. gv='5'","0=Unrated  1=Poor  2=Fair  3=Good  4=Very Good  5=Excellent"]
["RE037","EVAL_S","C",1,"Student Evaluation","9",false,"gv='0' .or. gv='1' .or. gv='2' .or. gv='3' .or. gv='4' .or. gv='5'","0=Unrated  1=Poor  2=Fair  3=Good  4=Very Good  5=Excellent"]
["RE038","STATUS","C",1,"Status","!",false,"gv='S' .or. gv='C' .or. gv='X' .or. gv='I' .or. gv='P'","S=Scheduled  C=Completed  X=Cancelled  I=In Progress  P=Postponed"]
["RE039","NOTES","M",10,"Notes",null,false,null,null]
["SW001","SHARENUM","C",7,"Product Code","!!!9999",false,null,null]
["SW002","SOFTWARE","C",30,"Software Product",null,false,null,null]
["SW003","VERSION","C",5,"Version Number","#####",false,null,null]
["SW004","COST","N",7,"Cost","9,999.99",false,null,null]
["SW005","SHIPPING","N",7,"Shipping Cost","9,999.99",false,null,null]
["SW006","NUMSOLD","N",6,"Number Sold","999,999",false,null,null]
["SW007","LANGUAGE","C",15,"Language Used",null,false,null,null]
["SW008","NOTES","M",10,"Notes",null,false,null,null]
["SH001","LASTNAME","C",15,"Last Name",null,false,null,null]
["SH002","FIRNAME","C",12,"First Name",null,false,null,null]
["SH003","COMPANY","C",30,"Company",null,false,null,null]
["SH004","TITLE","C",20,"Title",null,false,null,null]
["SH005","ADDR1","C",30,"Address-1",null,false,null,null]
["SH006","ADDR2","C",30,"Address-2",null,false,null,null]
["SH007","CITY","C",20,"City",null,false,null,null]
["SH008","STATE","C",2,"State","!!",false,null,null]
["SH009","ZIP","C",10,"Zip Code","!!!!!!!!!!",false,null,null]
["SH010","PROV","C",20,"Province",null,false,null,null]
["SH011","BPHONE","C",14,"Business Phone","(999) 999-9999",false,null,null]
["SH012","EXT","C",5,"Extension","#####",false,null,null]
["SH013","HPHONE","C",14,"Home Phone","(999) 999-9999",false,null,null]
["SH014","FAX","C",14,"Fax","(999) 999-9999",false,null,null]
["SH015","SOFTWARE","C",30,"Software Name",null,false,null,null]
["SH016","VERSION","C",5,"Version Number","#####",false,null,null]
["SH017","SHARENUM","C",7,"Product Code","!!!9999",false,null,null]
["SH018","REQUEST","D",8,"Date Requested","99/99/99",false,null,null]
["SH019","QUAN","N",5,"Quantity","99,999",false,null,null]
["SH020","ORDERBY","C",1,"How Ordered","!",false,"gv='T' .or. gv='F' .or. gv='L' .or. gv='P' .or. gv='O'","T=Telephone  F=Fax  L=Letter  P=Purchase Order  O=Other"]
["SH021","FEE","N",7,"Cost","9,999.99",false,null,null]
["SH022","SHIPPING","N",7,"Shipping","9,999.99",false,null,null]
["SH023","TAX","N",7,"Tax","9,999.99",false,null,null]
["SH024","TOTAL","N",9,"Total Amount","999,999.99",false,null,null]
["SH025","AMTPAID","N",9,"Amount Paid","999,999.99",false,null,null]
["SH026","HOWPAID","C",1,"How Paid","!",false,"gv='C' .or. gv='K' .or. gv='M' .or. gv='R' .or. gv='O'","C=Check  K=Cash  M=Money Order  R=Charge  O=Other"]
["SH027","CHECKNUM","C",5,"Check Number","#####",false,null,null]
["SH028","CHKDATE","D",8,"Check Date","99/99/99",false,null,null]
["SH029","CREDIT","C",1,"Charge Card","!",false,"gv='M' .or. gv='V' .or. gv='A' .or. gv='D' .or. gv='O'","M=Master Card  V=Visa  A=American Express  D=Discover  O=Optima"]
["SH030","CNUM","C",19,"Card Number","####-####-####-####",false,null,null]
["SH031","EXPIRE","C",5,"Expiration Date","99/99",false,null,null]
["SH032","BAL","N",9,"Balance Due","999,999.99",false,null,null]
["SH033","PAID_D","D",8,"Date Paid","99/99/99",false,null,null]
["SH034","RETURN","C",1,"Returned?","!",false,"gv='Y' .or. gv='N'","Y=Yes  N=No"]
["SH035","RETDATE","D",8,"Date Returned","99/99/99",false,null,null]
["SH036","UPGRADE","C",1,"Upgradeable?","!",false,"gv='Y' .or. gv='N'","Y=Yes  N=No"]
["SH037","SHIPDATE","D",8,"Date Shipped","99/99/99",false,null,null]
["SH038","NOTES","M",10,"Notes",null,false,null,null]
["NA017","bustele1","C",14,"Business Phone-1","(999) 999-9999",false,null,null]
["NA018","bustele2","C",14,"Business Phone-2","(999) 999-9999",false,null,null]
["NA019","busfax","C",14,"Business Fax-1","(999) 999-9999",false,null,null]
["NA020","busfax2","C",14,"Business Fax-2","(999) 999-9999",false,null,null]
["NA021","car","C",14,"Cellular Phone","(999) 999-9999",false,null,null]